// sql语句
var sqlMap = {
	user: {
		// 查询首页图片数据 where name like "%"?"%"'
		select: 'select * from images where type=?',
		// 查询闲置商品数据
		selectXz: 'select r.r_xz,r.time,u.userName,u.userImg,u.wechatNum,u.phoneNum,xz.price,xz.detail,xz.img1,xz.img2,xz.img3,xz.no,xz.like_value,xz.watch_value from zc_xz as xz join zc_releace r join user as u where xz.No = r.r_xz and r.openid = u.openid GROUP BY r.time  ORDER BY r.time DESC LIMIT ?,?',
		//user表新用户添加
		NewInsertTouser: 'INSERT INTO user(openid,userid,userName,userImg,userType,phoneNum,wechatNum,photo) VALUES(?,?,?,?,?,?,?,?)',
		//user表 通过微信唯一标识码openid 查询用户表内是否有该用户
		selectUser: 'SELECT * from user WHERE openid=?',
		//扑扑数据展示
		pupu: 'SELECT * from pupu_goods',
		//扑扑模糊查找
		pupulike: 'SELECT * from pupu_goods where name LIKE "%"?"%"',


	}
}

module.exports = sqlMap;
